You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-30, 30' at line 1
select auteur.id,prenom,nom,biblio as letexte,1 as type,biblio_lastupd as ladate,biblio_lastupdby as uid from auteur_bio, auteur where auteur.id = auteur_bio.aid and biblio is not null union select auteur.id,prenom,nom,auteur_bio.bio as letexte,2 as type,bio_lastupd as ladate,bio_lastupdby as uid from auteur_bio, auteur where auteur.id = auteur_bio.aid and auteur_bio.bio is not null order by 6 desc, 1 limit -30, 30